package com.ecoolex.hotel.saas.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class PresaleCouponOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public PresaleCouponOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public PresaleCouponOrderExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public PresaleCouponOrderExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        PresaleCouponOrderExample example = new PresaleCouponOrderExample();
        return example.createCriteria();
    }

    public PresaleCouponOrderExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public PresaleCouponOrderExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public PresaleCouponOrderExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public PresaleCouponOrderExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public PresaleCouponOrderExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("presalecouponorder.OrderId is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("presalecouponorder.OrderId is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(Integer value) {
            addCriterion("presalecouponorder.OrderId =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OrderId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(Integer value) {
            addCriterion("presalecouponorder.OrderId <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OrderId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(Integer value) {
            addCriterion("presalecouponorder.OrderId >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OrderId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("presalecouponorder.OrderId >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OrderId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(Integer value) {
            addCriterion("presalecouponorder.OrderId <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OrderId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(Integer value) {
            addCriterion("presalecouponorder.OrderId <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OrderId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<Integer> values) {
            addCriterion("presalecouponorder.OrderId in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<Integer> values) {
            addCriterion("presalecouponorder.OrderId not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(Integer value1, Integer value2) {
            addCriterion("presalecouponorder.OrderId between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(Integer value1, Integer value2) {
            addCriterion("presalecouponorder.OrderId not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("presalecouponorder.OrderNo is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("presalecouponorder.OrderNo is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("presalecouponorder.OrderNo =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OrderNo = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("presalecouponorder.OrderNo <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OrderNo <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("presalecouponorder.OrderNo >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OrderNo > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.OrderNo >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OrderNo >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("presalecouponorder.OrderNo <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OrderNo < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.OrderNo <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OrderNo <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("presalecouponorder.OrderNo like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("presalecouponorder.OrderNo not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("presalecouponorder.OrderNo in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("presalecouponorder.OrderNo not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("presalecouponorder.OrderNo between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("presalecouponorder.OrderNo not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("presalecouponorder.UserId is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("presalecouponorder.UserId is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Integer value) {
            addCriterion("presalecouponorder.UserId =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Integer value) {
            addCriterion("presalecouponorder.UserId <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Integer value) {
            addCriterion("presalecouponorder.UserId >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("presalecouponorder.UserId >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Integer value) {
            addCriterion("presalecouponorder.UserId <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("presalecouponorder.UserId <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Integer> values) {
            addCriterion("presalecouponorder.UserId in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Integer> values) {
            addCriterion("presalecouponorder.UserId not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Integer value1, Integer value2) {
            addCriterion("presalecouponorder.UserId between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("presalecouponorder.UserId not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserNameIsNull() {
            addCriterion("presalecouponorder.UserName is null");
            return (Criteria) this;
        }

        public Criteria andUserNameIsNotNull() {
            addCriterion("presalecouponorder.UserName is not null");
            return (Criteria) this;
        }

        public Criteria andUserNameEqualTo(String value) {
            addCriterion("presalecouponorder.UserName =", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserName = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserNameNotEqualTo(String value) {
            addCriterion("presalecouponorder.UserName <>", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserName <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserNameGreaterThan(String value) {
            addCriterion("presalecouponorder.UserName >", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserName > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.UserName >=", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserName >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserNameLessThan(String value) {
            addCriterion("presalecouponorder.UserName <", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserName < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserNameLessThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.UserName <=", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserName <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserNameLike(String value) {
            addCriterion("presalecouponorder.UserName like", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotLike(String value) {
            addCriterion("presalecouponorder.UserName not like", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameIn(List<String> values) {
            addCriterion("presalecouponorder.UserName in", values, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotIn(List<String> values) {
            addCriterion("presalecouponorder.UserName not in", values, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameBetween(String value1, String value2) {
            addCriterion("presalecouponorder.UserName between", value1, value2, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotBetween(String value1, String value2) {
            addCriterion("presalecouponorder.UserName not between", value1, value2, "userName");
            return (Criteria) this;
        }

        public Criteria andUserPhoneIsNull() {
            addCriterion("presalecouponorder.UserPhone is null");
            return (Criteria) this;
        }

        public Criteria andUserPhoneIsNotNull() {
            addCriterion("presalecouponorder.UserPhone is not null");
            return (Criteria) this;
        }

        public Criteria andUserPhoneEqualTo(String value) {
            addCriterion("presalecouponorder.UserPhone =", value, "userPhone");
            return (Criteria) this;
        }

        public Criteria andUserPhoneEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserPhone = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserPhoneNotEqualTo(String value) {
            addCriterion("presalecouponorder.UserPhone <>", value, "userPhone");
            return (Criteria) this;
        }

        public Criteria andUserPhoneNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserPhone <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserPhoneGreaterThan(String value) {
            addCriterion("presalecouponorder.UserPhone >", value, "userPhone");
            return (Criteria) this;
        }

        public Criteria andUserPhoneGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserPhone > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.UserPhone >=", value, "userPhone");
            return (Criteria) this;
        }

        public Criteria andUserPhoneGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserPhone >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserPhoneLessThan(String value) {
            addCriterion("presalecouponorder.UserPhone <", value, "userPhone");
            return (Criteria) this;
        }

        public Criteria andUserPhoneLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserPhone < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserPhoneLessThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.UserPhone <=", value, "userPhone");
            return (Criteria) this;
        }

        public Criteria andUserPhoneLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UserPhone <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserPhoneLike(String value) {
            addCriterion("presalecouponorder.UserPhone like", value, "userPhone");
            return (Criteria) this;
        }

        public Criteria andUserPhoneNotLike(String value) {
            addCriterion("presalecouponorder.UserPhone not like", value, "userPhone");
            return (Criteria) this;
        }

        public Criteria andUserPhoneIn(List<String> values) {
            addCriterion("presalecouponorder.UserPhone in", values, "userPhone");
            return (Criteria) this;
        }

        public Criteria andUserPhoneNotIn(List<String> values) {
            addCriterion("presalecouponorder.UserPhone not in", values, "userPhone");
            return (Criteria) this;
        }

        public Criteria andUserPhoneBetween(String value1, String value2) {
            addCriterion("presalecouponorder.UserPhone between", value1, value2, "userPhone");
            return (Criteria) this;
        }

        public Criteria andUserPhoneNotBetween(String value1, String value2) {
            addCriterion("presalecouponorder.UserPhone not between", value1, value2, "userPhone");
            return (Criteria) this;
        }

        public Criteria andSalesUserIdIsNull() {
            addCriterion("presalecouponorder.SalesUserId is null");
            return (Criteria) this;
        }

        public Criteria andSalesUserIdIsNotNull() {
            addCriterion("presalecouponorder.SalesUserId is not null");
            return (Criteria) this;
        }

        public Criteria andSalesUserIdEqualTo(Integer value) {
            addCriterion("presalecouponorder.SalesUserId =", value, "salesUserId");
            return (Criteria) this;
        }

        public Criteria andSalesUserIdEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.SalesUserId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSalesUserIdNotEqualTo(Integer value) {
            addCriterion("presalecouponorder.SalesUserId <>", value, "salesUserId");
            return (Criteria) this;
        }

        public Criteria andSalesUserIdNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.SalesUserId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSalesUserIdGreaterThan(Integer value) {
            addCriterion("presalecouponorder.SalesUserId >", value, "salesUserId");
            return (Criteria) this;
        }

        public Criteria andSalesUserIdGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.SalesUserId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSalesUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("presalecouponorder.SalesUserId >=", value, "salesUserId");
            return (Criteria) this;
        }

        public Criteria andSalesUserIdGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.SalesUserId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSalesUserIdLessThan(Integer value) {
            addCriterion("presalecouponorder.SalesUserId <", value, "salesUserId");
            return (Criteria) this;
        }

        public Criteria andSalesUserIdLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.SalesUserId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSalesUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("presalecouponorder.SalesUserId <=", value, "salesUserId");
            return (Criteria) this;
        }

        public Criteria andSalesUserIdLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.SalesUserId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSalesUserIdIn(List<Integer> values) {
            addCriterion("presalecouponorder.SalesUserId in", values, "salesUserId");
            return (Criteria) this;
        }

        public Criteria andSalesUserIdNotIn(List<Integer> values) {
            addCriterion("presalecouponorder.SalesUserId not in", values, "salesUserId");
            return (Criteria) this;
        }

        public Criteria andSalesUserIdBetween(Integer value1, Integer value2) {
            addCriterion("presalecouponorder.SalesUserId between", value1, value2, "salesUserId");
            return (Criteria) this;
        }

        public Criteria andSalesUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("presalecouponorder.SalesUserId not between", value1, value2, "salesUserId");
            return (Criteria) this;
        }

        public Criteria andCommissionIsNull() {
            addCriterion("presalecouponorder.Commission is null");
            return (Criteria) this;
        }

        public Criteria andCommissionIsNotNull() {
            addCriterion("presalecouponorder.Commission is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionEqualTo(BigDecimal value) {
            addCriterion("presalecouponorder.Commission =", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Commission = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCommissionNotEqualTo(BigDecimal value) {
            addCriterion("presalecouponorder.Commission <>", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Commission <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThan(BigDecimal value) {
            addCriterion("presalecouponorder.Commission >", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Commission > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("presalecouponorder.Commission >=", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Commission >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCommissionLessThan(BigDecimal value) {
            addCriterion("presalecouponorder.Commission <", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Commission < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCommissionLessThanOrEqualTo(BigDecimal value) {
            addCriterion("presalecouponorder.Commission <=", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Commission <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCommissionIn(List<BigDecimal> values) {
            addCriterion("presalecouponorder.Commission in", values, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotIn(List<BigDecimal> values) {
            addCriterion("presalecouponorder.Commission not in", values, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("presalecouponorder.Commission between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("presalecouponorder.Commission not between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria andTotalPriceIsNull() {
            addCriterion("presalecouponorder.TotalPrice is null");
            return (Criteria) this;
        }

        public Criteria andTotalPriceIsNotNull() {
            addCriterion("presalecouponorder.TotalPrice is not null");
            return (Criteria) this;
        }

        public Criteria andTotalPriceEqualTo(BigDecimal value) {
            addCriterion("presalecouponorder.TotalPrice =", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.TotalPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotEqualTo(BigDecimal value) {
            addCriterion("presalecouponorder.TotalPrice <>", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.TotalPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThan(BigDecimal value) {
            addCriterion("presalecouponorder.TotalPrice >", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.TotalPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("presalecouponorder.TotalPrice >=", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.TotalPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThan(BigDecimal value) {
            addCriterion("presalecouponorder.TotalPrice <", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.TotalPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("presalecouponorder.TotalPrice <=", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.TotalPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceIn(List<BigDecimal> values) {
            addCriterion("presalecouponorder.TotalPrice in", values, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotIn(List<BigDecimal> values) {
            addCriterion("presalecouponorder.TotalPrice not in", values, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("presalecouponorder.TotalPrice between", value1, value2, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("presalecouponorder.TotalPrice not between", value1, value2, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceIsNull() {
            addCriterion("presalecouponorder.RealPrice is null");
            return (Criteria) this;
        }

        public Criteria andRealPriceIsNotNull() {
            addCriterion("presalecouponorder.RealPrice is not null");
            return (Criteria) this;
        }

        public Criteria andRealPriceEqualTo(BigDecimal value) {
            addCriterion("presalecouponorder.RealPrice =", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.RealPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceNotEqualTo(BigDecimal value) {
            addCriterion("presalecouponorder.RealPrice <>", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.RealPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceGreaterThan(BigDecimal value) {
            addCriterion("presalecouponorder.RealPrice >", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.RealPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("presalecouponorder.RealPrice >=", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.RealPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceLessThan(BigDecimal value) {
            addCriterion("presalecouponorder.RealPrice <", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.RealPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("presalecouponorder.RealPrice <=", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.RealPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceIn(List<BigDecimal> values) {
            addCriterion("presalecouponorder.RealPrice in", values, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceNotIn(List<BigDecimal> values) {
            addCriterion("presalecouponorder.RealPrice not in", values, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("presalecouponorder.RealPrice between", value1, value2, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("presalecouponorder.RealPrice not between", value1, value2, "realPrice");
            return (Criteria) this;
        }

        public Criteria andPaymentNoIsNull() {
            addCriterion("presalecouponorder.PaymentNo is null");
            return (Criteria) this;
        }

        public Criteria andPaymentNoIsNotNull() {
            addCriterion("presalecouponorder.PaymentNo is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentNoEqualTo(String value) {
            addCriterion("presalecouponorder.PaymentNo =", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentNo = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotEqualTo(String value) {
            addCriterion("presalecouponorder.PaymentNo <>", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentNo <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThan(String value) {
            addCriterion("presalecouponorder.PaymentNo >", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentNo > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.PaymentNo >=", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentNo >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThan(String value) {
            addCriterion("presalecouponorder.PaymentNo <", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentNo < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.PaymentNo <=", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentNo <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoLike(String value) {
            addCriterion("presalecouponorder.PaymentNo like", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotLike(String value) {
            addCriterion("presalecouponorder.PaymentNo not like", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoIn(List<String> values) {
            addCriterion("presalecouponorder.PaymentNo in", values, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotIn(List<String> values) {
            addCriterion("presalecouponorder.PaymentNo not in", values, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoBetween(String value1, String value2) {
            addCriterion("presalecouponorder.PaymentNo between", value1, value2, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotBetween(String value1, String value2) {
            addCriterion("presalecouponorder.PaymentNo not between", value1, value2, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIsNull() {
            addCriterion("presalecouponorder.PaymentType is null");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIsNotNull() {
            addCriterion("presalecouponorder.PaymentType is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeEqualTo(Integer value) {
            addCriterion("presalecouponorder.PaymentType =", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentType = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotEqualTo(Integer value) {
            addCriterion("presalecouponorder.PaymentType <>", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentType <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTypeGreaterThan(Integer value) {
            addCriterion("presalecouponorder.PaymentType >", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentType > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("presalecouponorder.PaymentType >=", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentType >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLessThan(Integer value) {
            addCriterion("presalecouponorder.PaymentType <", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentType < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLessThanOrEqualTo(Integer value) {
            addCriterion("presalecouponorder.PaymentType <=", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentType <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIn(List<Integer> values) {
            addCriterion("presalecouponorder.PaymentType in", values, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotIn(List<Integer> values) {
            addCriterion("presalecouponorder.PaymentType not in", values, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeBetween(Integer value1, Integer value2) {
            addCriterion("presalecouponorder.PaymentType between", value1, value2, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("presalecouponorder.PaymentType not between", value1, value2, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIsNull() {
            addCriterion("presalecouponorder.PaymentTime is null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIsNotNull() {
            addCriterion("presalecouponorder.PaymentTime is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeEqualTo(Date value) {
            addCriterion("presalecouponorder.PaymentTime =", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotEqualTo(Date value) {
            addCriterion("presalecouponorder.PaymentTime <>", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThan(Date value) {
            addCriterion("presalecouponorder.PaymentTime >", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("presalecouponorder.PaymentTime >=", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThan(Date value) {
            addCriterion("presalecouponorder.PaymentTime <", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanOrEqualTo(Date value) {
            addCriterion("presalecouponorder.PaymentTime <=", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.PaymentTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIn(List<Date> values) {
            addCriterion("presalecouponorder.PaymentTime in", values, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotIn(List<Date> values) {
            addCriterion("presalecouponorder.PaymentTime not in", values, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeBetween(Date value1, Date value2) {
            addCriterion("presalecouponorder.PaymentTime between", value1, value2, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotBetween(Date value1, Date value2) {
            addCriterion("presalecouponorder.PaymentTime not between", value1, value2, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andStoreIdIsNull() {
            addCriterion("presalecouponorder.StoreId is null");
            return (Criteria) this;
        }

        public Criteria andStoreIdIsNotNull() {
            addCriterion("presalecouponorder.StoreId is not null");
            return (Criteria) this;
        }

        public Criteria andStoreIdEqualTo(Integer value) {
            addCriterion("presalecouponorder.StoreId =", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.StoreId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStoreIdNotEqualTo(Integer value) {
            addCriterion("presalecouponorder.StoreId <>", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.StoreId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStoreIdGreaterThan(Integer value) {
            addCriterion("presalecouponorder.StoreId >", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.StoreId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStoreIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("presalecouponorder.StoreId >=", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.StoreId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStoreIdLessThan(Integer value) {
            addCriterion("presalecouponorder.StoreId <", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.StoreId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStoreIdLessThanOrEqualTo(Integer value) {
            addCriterion("presalecouponorder.StoreId <=", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.StoreId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStoreIdIn(List<Integer> values) {
            addCriterion("presalecouponorder.StoreId in", values, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdNotIn(List<Integer> values) {
            addCriterion("presalecouponorder.StoreId not in", values, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdBetween(Integer value1, Integer value2) {
            addCriterion("presalecouponorder.StoreId between", value1, value2, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdNotBetween(Integer value1, Integer value2) {
            addCriterion("presalecouponorder.StoreId not between", value1, value2, "storeId");
            return (Criteria) this;
        }

        public Criteria andUseTimeIsNull() {
            addCriterion("presalecouponorder.UseTime is null");
            return (Criteria) this;
        }

        public Criteria andUseTimeIsNotNull() {
            addCriterion("presalecouponorder.UseTime is not null");
            return (Criteria) this;
        }

        public Criteria andUseTimeEqualTo(Date value) {
            addCriterion("presalecouponorder.UseTime =", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UseTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUseTimeNotEqualTo(Date value) {
            addCriterion("presalecouponorder.UseTime <>", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UseTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUseTimeGreaterThan(Date value) {
            addCriterion("presalecouponorder.UseTime >", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UseTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUseTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("presalecouponorder.UseTime >=", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UseTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUseTimeLessThan(Date value) {
            addCriterion("presalecouponorder.UseTime <", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UseTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUseTimeLessThanOrEqualTo(Date value) {
            addCriterion("presalecouponorder.UseTime <=", value, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UseTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUseTimeIn(List<Date> values) {
            addCriterion("presalecouponorder.UseTime in", values, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeNotIn(List<Date> values) {
            addCriterion("presalecouponorder.UseTime not in", values, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeBetween(Date value1, Date value2) {
            addCriterion("presalecouponorder.UseTime between", value1, value2, "useTime");
            return (Criteria) this;
        }

        public Criteria andUseTimeNotBetween(Date value1, Date value2) {
            addCriterion("presalecouponorder.UseTime not between", value1, value2, "useTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeIsNull() {
            addCriterion("presalecouponorder.CancelTime is null");
            return (Criteria) this;
        }

        public Criteria andCancelTimeIsNotNull() {
            addCriterion("presalecouponorder.CancelTime is not null");
            return (Criteria) this;
        }

        public Criteria andCancelTimeEqualTo(Date value) {
            addCriterion("presalecouponorder.CancelTime =", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.CancelTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelTimeNotEqualTo(Date value) {
            addCriterion("presalecouponorder.CancelTime <>", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.CancelTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelTimeGreaterThan(Date value) {
            addCriterion("presalecouponorder.CancelTime >", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.CancelTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("presalecouponorder.CancelTime >=", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.CancelTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelTimeLessThan(Date value) {
            addCriterion("presalecouponorder.CancelTime <", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.CancelTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelTimeLessThanOrEqualTo(Date value) {
            addCriterion("presalecouponorder.CancelTime <=", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.CancelTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelTimeIn(List<Date> values) {
            addCriterion("presalecouponorder.CancelTime in", values, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeNotIn(List<Date> values) {
            addCriterion("presalecouponorder.CancelTime not in", values, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeBetween(Date value1, Date value2) {
            addCriterion("presalecouponorder.CancelTime between", value1, value2, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeNotBetween(Date value1, Date value2) {
            addCriterion("presalecouponorder.CancelTime not between", value1, value2, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("presalecouponorder.Remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("presalecouponorder.Remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("presalecouponorder.Remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Remark = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("presalecouponorder.Remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Remark <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("presalecouponorder.Remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Remark > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.Remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Remark >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("presalecouponorder.Remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Remark < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.Remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Remark <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("presalecouponorder.Remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("presalecouponorder.Remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("presalecouponorder.Remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("presalecouponorder.Remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("presalecouponorder.Remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("presalecouponorder.Remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceIsNull() {
            addCriterion("presalecouponorder.OfflinePayEvidence is null");
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceIsNotNull() {
            addCriterion("presalecouponorder.OfflinePayEvidence is not null");
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceEqualTo(String value) {
            addCriterion("presalecouponorder.OfflinePayEvidence =", value, "offlinePayEvidence");
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OfflinePayEvidence = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceNotEqualTo(String value) {
            addCriterion("presalecouponorder.OfflinePayEvidence <>", value, "offlinePayEvidence");
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OfflinePayEvidence <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceGreaterThan(String value) {
            addCriterion("presalecouponorder.OfflinePayEvidence >", value, "offlinePayEvidence");
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OfflinePayEvidence > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceGreaterThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.OfflinePayEvidence >=", value, "offlinePayEvidence");
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OfflinePayEvidence >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceLessThan(String value) {
            addCriterion("presalecouponorder.OfflinePayEvidence <", value, "offlinePayEvidence");
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OfflinePayEvidence < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceLessThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.OfflinePayEvidence <=", value, "offlinePayEvidence");
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.OfflinePayEvidence <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceLike(String value) {
            addCriterion("presalecouponorder.OfflinePayEvidence like", value, "offlinePayEvidence");
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceNotLike(String value) {
            addCriterion("presalecouponorder.OfflinePayEvidence not like", value, "offlinePayEvidence");
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceIn(List<String> values) {
            addCriterion("presalecouponorder.OfflinePayEvidence in", values, "offlinePayEvidence");
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceNotIn(List<String> values) {
            addCriterion("presalecouponorder.OfflinePayEvidence not in", values, "offlinePayEvidence");
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceBetween(String value1, String value2) {
            addCriterion("presalecouponorder.OfflinePayEvidence between", value1, value2, "offlinePayEvidence");
            return (Criteria) this;
        }

        public Criteria andOfflinePayEvidenceNotBetween(String value1, String value2) {
            addCriterion("presalecouponorder.OfflinePayEvidence not between", value1, value2, "offlinePayEvidence");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("presalecouponorder.`Status` is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("presalecouponorder.`Status` is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("presalecouponorder.`Status` =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.`Status` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("presalecouponorder.`Status` <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.`Status` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("presalecouponorder.`Status` >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.`Status` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("presalecouponorder.`Status` >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.`Status` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("presalecouponorder.`Status` <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.`Status` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("presalecouponorder.`Status` <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.`Status` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("presalecouponorder.`Status` in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("presalecouponorder.`Status` not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("presalecouponorder.`Status` between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("presalecouponorder.`Status` not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("presalecouponorder.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("presalecouponorder.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("presalecouponorder.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("presalecouponorder.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("presalecouponorder.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("presalecouponorder.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("presalecouponorder.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("presalecouponorder.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("presalecouponorder.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("presalecouponorder.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("presalecouponorder.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("presalecouponorder.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("presalecouponorder.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("presalecouponorder.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("presalecouponorder.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("presalecouponorder.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("presalecouponorder.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("presalecouponorder.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("presalecouponorder.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("presalecouponorder.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("presalecouponorder.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("presalecouponorder.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("presalecouponorder.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("presalecouponorder.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("presalecouponorder.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("presalecouponorder.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("presalecouponorder.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("presalecouponorder.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("presalecouponorder.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("presalecouponorder.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("presalecouponorder.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("presalecouponorder.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("presalecouponorder.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("presalecouponorder.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("presalecouponorder.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("presalecouponorder.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("presalecouponorder.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("presalecouponorder.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("presalecouponorder.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("presalecouponorder.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("presalecouponorder.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("presalecouponorder.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("presalecouponorder.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("presalecouponorder.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("presalecouponorder.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("presalecouponorder.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("presalecouponorder.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("presalecouponorder.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("presalecouponorder.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("presalecouponorder.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("presalecouponorder.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("presalecouponorder.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("presalecouponorder.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("presalecouponorder.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("presalecouponorder.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("presalecouponorder.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("presalecouponorder.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(PresaleCouponOrder.Column column) {
            addCriterion(new StringBuilder("presalecouponorder.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("presalecouponorder.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("presalecouponorder.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("presalecouponorder.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("presalecouponorder.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private PresaleCouponOrderExample example;

        protected Criteria(PresaleCouponOrderExample example) {
            super();
            this.example = example;
        }

        public PresaleCouponOrderExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(PresaleCouponOrder.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(PresaleCouponOrder.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.hotel.saas.entity.PresaleCouponOrderExample example);
    }
}